home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Software Vault: The Gold Collection
/
Software Vault - The Gold Collection (American Databankers) (1993).ISO
/
cdr11
/
pdox693.zip
/
TI528.ASC
< prev
next >
Wrap
Text File
|
1992-09-03
|
2KB
|
133 lines
PRODUCT : PARADOX NUMBER : 528
VERSION : ALL
OS : DOS
DATE : September 3, 1992 PAGE : 1/2
TITLE : SCRIPT TO CONVERT A SINGLE NAME FIELD
INTO MULTIPLE FIELDS
This script will convert a Name field into four possible fields
(title, first, initial, and last). The Name field can contain
the following data:
Title First Initial Last
or
Title First Last
or
Title Last
The script illustrates the use of the PAL commands SCAN & SWITCH
and the PAL MATCH function.
The following is the Script:
EDIT "NAME" ; Edit a Table called NAME.
SCAN
; Now, MATCH a field named Full Name for the following scenarios.
x=MATCH([Full name], ".. .. .. ..", m, f, i, l)
y=MATCH([Full name], ".. .. ..", m1, f1, l1)
z=MATCH([Full name], ".. ..", m2, l2)
SWITCH
CASE x : [First]=f
[Initial]=i
[Last]=l
[Title]=m
CASE y : [First]=f1
[Last]=l1
[Title]=m1
CASE z : [Last]=l2
[Title]=m2
ENDSWITCH
ENDSCAN
PRODUCT : PARADOX NUMBER : 528
VERSION : ALL
OS : DOS
DATE : September 3, 1992 PAGE : 2/2
TITLE : SCRIPT TO CONVERT A SINGLE NAME FIELD
INTO MULTIPLE FIELDS
DISCLAIMER: You have the right to use this technical information
subject to the terms of the No-Nonsense License Statement that
you received with the Borland product to which this information
pertains.